
INSERT INTO regions
	VALUES (s_regions.NEXTVAL, 'Australia')

INSERT INTO regions
	VALUES (s_regions.NEXTVAL, 'Antarctica')


INSERT INTO countries
	VALUES ('UA', 'Ukraine', 1)

INSERT INTO countries
	VALUES ('RU', 'Russian Federation', 1)


INSERT INTO locations
	VALUES (s_locations.NEXTVAL, 'Somewhere', '12345', 'Odessa', 'Odessa', 'UA')

INSERT INTO locations
	VALUES (s_locations.NEXTVAL, 'Somewhere in Russia', '67890', 'Moscow', 'Moscow', 'RU')


INSERT INTO departments
	VALUES (s_departments.NEXTVAL, 'Department1', 158, 3300)

INSERT INTO departments
	VALUES (s_departments.NEXTVAL, 'Department2', 159, 3400)


INSERT INTO jobs
	VALUES ('J1', 'Job1', 10000, 20000)

INSERT INTO jobs
	VALUES ('J2', 'Job2', 30000, 40000)


INSERT INTO employees
	VALUES (s_employees.NEXTVAL, 'Ivan', 'Ivanov', 'ii@mail.com', '12-34-56', 
			TO_DATE('09-09-2013', 'dd-mm-yyyy'), 'J1', 15000, 0.05, 158, 280)

INSERT INTO employees
	VALUES (s_employees.NEXTVAL, 'Petr', 'Petrov', 'pp@mail.com', '78-90-12', 
			TO_DATE('10-10-2013', 'dd-mm-yyyy'), 'J2', 35000, 0.10, 159, 290)


INSERT INTO job_history
	VALUES (207, TO_DATE('09-09-2013', 'dd-mm-yyyy'), 
			TO_DATE('10-09-2013', 'dd-mm-yyyy'), 'J1', 280)

INSERT INTO job_history
	VALUES (208, TO_DATE('10-10-2013', 'dd-mm-yyyy'), 
			TO_DATE('11-10-2013', 'dd-mm-yyyy'), 'J2', 290)


COMMIT
